﻿CREATE PROCEDURE [dbo].[Text_BookTree_GetHeaders]
AS
BEGIN
	SELECT c.[Url]
				,t.[UpdateDate]
				,t.[Text]
	FROM [dbo].[text_BookTree_Cache] AS c
	JOIN [dbo].[text_BookTree] AS t ON c.[BookTreeId] = t.[BookTreeId]
	WHERE t.[Published] = 1
END